﻿-- =============================================
-- Script Template
-- =============================================
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

/****Create Default Records ****/
PRINT 'INSERTING DEFAULT DATA .... [UserOrganizationRole]'
GO
INSERT [UserOrganizationRole] ([UserKey], [UserOrganizationKey], [UserRoleKey], [UserLoginID], [UserOrganizationCode], [UserOrganizationName], [UserRoleCode], [UserRoleName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, -1, 1, N'SystemSuperAdmin', N'SYSTEM', N'FrameworkIvy Website', N'SYSSPRADM', N'System Super Admin', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [UserOrganizationRole] ([UserKey], [UserOrganizationKey], [UserRoleKey], [UserLoginID], [UserOrganizationCode], [UserOrganizationName], [UserRoleCode], [UserRoleName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, -1, 4, N'SystemSuperAdmin', N'SYSTEM', N'FrameworkIvy Website', N'SYSREGUSR', N'System Registered User', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))


--INSERT [UserOrganizationRole] ([UserKey], [UserOrganizationKey], [UserRoleKey], [UserLoginID], [UserSocietyCode], [UserSocietyName], [UserRoleCode], [UserRoleName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, -1, 4, N'SystemSuperAdmin', N'SYSTEM', N'Default Organization is this System Portal or Web site', N'SYSREGUSR', N'System Registered User', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
--INSERT [UserOrganizationRole] ([UserKey], [UserOrganizationKey], [UserRoleKey], [UserLoginID], [UserSocietyCode], [UserSocietyName], [UserRoleCode], [UserRoleName], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, -1, 1, N'SystemSuperAdmin', N'SYSTEM', N'Default Organization is this System Portal or Web site', N'SYSSPRADM', N'System Super Admin', GETDATE(), GETDATE(), N'1', N'1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))